CREATE TABLE [dbo].[ContactCommunicationReasonPreferences]
(
[ContactKey] [uniqueidentifier] NOT NULL,
[CommunicationReasonKey] [uniqueidentifier] NOT NULL,
[PreferredAddressCategoryCode] [int] NULL,
[NoCommunicationByMailFlag] [bit] NOT NULL CONSTRAINT [DF_ContactCommunicationReasonPreferences_NoCommunicationByMailFlag] DEFAULT ((0)),
[NoCommunicationByPhoneFlag] [bit] NOT NULL CONSTRAINT [DF_ContactCommunicationReasonPreferences_NoCommunicationByPhoneFlag] DEFAULT ((0)),
[NoCommunicationByFaxFlag] [bit] NOT NULL CONSTRAINT [DF_ContactCommunicationReasonPreferences_NoCommunicationByFaxFlag] DEFAULT ((0)),
[NoCommunicationByEmailFlag] [bit] NOT NULL CONSTRAINT [DF_ContactCommunicationReasonPreferences_NoCommunicationByEmailFlag] DEFAULT ((0)),
[ContactCommunicationReasonPreferencesKey] [uniqueidentifier] NOT NULL,
[MarkedForDeleteOn] [datetime] NULL
) ON [PRIMARY]

GO
ALTER TABLE [dbo].[ContactCommunicationReasonPreferences] ADD CONSTRAINT [PK_ContactCommunicationReasonPreferences] PRIMARY KEY CLUSTERED ([ContactCommunicationReasonPreferencesKey]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[ContactCommunicationReasonPreferences] ADD CONSTRAINT [AK_ContactCommunicationReasonPreferences] UNIQUE NONCLUSTERED ([ContactKey], [CommunicationReasonKey]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[ContactCommunicationReasonPreferences] ADD CONSTRAINT [FK_ContactCommunicationReasonPreferences_AddressCategoryRef] FOREIGN KEY ([PreferredAddressCategoryCode]) REFERENCES [dbo].[AddressCategoryRef] ([AddressCategoryCode])
GO
ALTER TABLE [dbo].[ContactCommunicationReasonPreferences] ADD CONSTRAINT [FK_ContactCommunicationReasonPreferences_CommunicationReasonRef] FOREIGN KEY ([CommunicationReasonKey]) REFERENCES [dbo].[CommunicationReasonRef] ([CommunicationReasonKey])
GO
ALTER TABLE [dbo].[ContactCommunicationReasonPreferences] ADD CONSTRAINT [FK_ContactCommunicationReasonPreferences_ContactMain] FOREIGN KEY ([ContactKey]) REFERENCES [dbo].[ContactMain] ([ContactKey])
GO